create  table jms_dm.dm_door_sign_rate_export_dt 
(
date_time timestamp COMMENT '' ,
agent_code varchar(100) COMMENT '' ,
agent_name varchar(100) COMMENT '' ,
code varchar(100) COMMENT '' ,
name varchar(100) COMMENT '' ,
business_name varchar(100) COMMENT '' ,
ordersource_flg  varchar(100) COMMENT '订单来源' ,
cnt varchar(100) COMMENT '' )
ENGINE=OLAP
DUPLICATE KEY(填写key)
comment 'insert overwrite table jms_dm.dm_door_sign_rate_export_dt partition ( dt )'
PARTITION BY RANGE (date_time) ( 
   START ("2023-04-12") END ("2023-06-11") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(site_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);